How to restore backup file in MySQL database? Pravesh Singh371912-Mar-2012 Hello Everyone, I'm facing a problem in restoring backup file in MySQL database. So can anyone help me how to solve this problem.Thanks in advance!! mysqlmysql Updated on 12-Mar-2012
Anonymous User
12-Mar-2012To restore MySQL database backup file, you have just use LOAD DATA INFILE query like this...
Query:LOAD DATA INFILE '$backupFile' INTO TABLE $tableName ;
Where,
$backupFile -> is backup file name with path.
$tableName -> is table name in which you will load or insert data.
I hope it will be solve your problem.